using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Runtime.InteropServices;
using System.Data.SqlClient;

namespace WindowsApplication1
{
    class SQL
    {
        public static string getCon = "server=222.16.73.133;database=YHXT;uid=sa;pwd=123;";
        //public static string getCon = "server=.;database=ykxt;uid=sa;pwd=123;";


        //public class IniFile
        //{
        //    private string FFileName;
        //    [DllImport("kernel32")]
        //    private static extern int GetPrivateProfileInt(
        //    string lpAppName,
        //    string lpKeyName,
        //    int nDefault,
        //    string lpFileName
        //    );
        //    [DllImport("kernel32")]
        //    private static extern int GetPrivateProfileString(
        //    string lpAppName,
        //    string lpKeyName,
        //    string lpDefault,
        //    StringBuilder lpReturnedString,
        //    int nSize,
        //    string lpFileName
        //    );
        //    [DllImport("kernel32")]
        //    private static extern bool WritePrivateProfileString(
        //    string lpAppName,
        //    string lpKeyName,
        //    string lpString,
        //    string lpFileName
        //    );
        //    public IniFile(string filename)
        //    {
        //        FFileName = filename;
        //    }
        //    public int ReadInt(string section, string key, int def)
        //    {
        //        return GetPrivateProfileInt(section, key, def, FFileName);
        //    }
        //    public string ReadString(string section, string key, string def)
        //    {
        //        StringBuilder temp = new StringBuilder(1024);
        //        GetPrivateProfileString(section, key, def, temp, 1024, FFileName);
        //        return temp.ToString();
        //    }
        //    public void WriteInt(string section, string key, int iVal)
        //    {
        //        WritePrivateProfileString(section, key, iVal.ToString(), FFileName);
        //    }
        //    public void WriteString(string section, string key, string strVal)
        //    {
        //        WritePrivateProfileString(section, key, strVal, FFileName);
        //    }
        //    public void DelKey(string section, string key)
        //    {
        //        WritePrivateProfileString(section, key, null, FFileName);
        //    }
        //    public void DelSection(string section)
        //    {
        //        WritePrivateProfileString(section, null, null, FFileName);
        //    }
        //}

        //public static String Database = System.IO.Directory.GetCurrentDirectory() + "\\YKXT.mdf";
        //public static string getCon()
        //{
           
        //    //IniFile g = new IniFile("C:\\YKXT\\test.ini");
            
        //    //SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder();
        //    //sb.IntegratedSecurity = false;
        //    //sb.DataSource = g.ReadString("YKXT_MSSQL", "Server Name", ""); ;
        //    //sb.InitialCatalog = g.ReadString("YKXT_MSSQL", "Database Name", "");
        //    //sb.UserID = g.ReadString("YKXT_MSSQL", "UserID", "");
        //    //sb.Password = g.ReadString("YKXT_MSSQL", "Password", "");
        //    ////sb.ConnectTimeout = 1;
        //    //////string SqlConnectString = sb.ConnectionString;
        //    //sb.IntegratedSecurity = true;
        //    //return sb.ConnectionString;


        //    SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder();
        //    sb.DataSource = ".";
        //    sb.InitialCatalog = "YKXT";
        //    sb.IntegratedSecurity = true;
        //    return sb.ConnectionString;
        //}
    }
}
